

use "../Raw/SBTI/sbti.dta", clear

drop if missing(bankname)
rename bankname BankName

drop sector organizationtype target targetclassification extension

drop longterm*
drop netzeroyear

gen date_sbti=date(date, "DM20Y")
gen year_sbti=yofd(date_sbti)

gen ba15_d=(ba15=="Yes")
gen netzero_d=(netzerocommitted=="Yes")

gen targetset=(neartermtargetstatus=="Targets Set")

save "../Intermediate/sbti_clean.dta", replace
